Integrating relational and object-oriented database systems using a metaclass concept

نویسندگان

  • Wolfgang Klas
  • Gisela Fischer
  • Karl Aberer
چکیده

This paper presents a specific approach of integrating a relational database system into a federated database system. The underlying database integration process consist of three steps: first, the external database systems have to be connected to the integrated database system environment and the external data models have to be mapped into a canonical data model. This step is often called syntactic transformation including structural enrichment and leads to component schemas for each external DBMS. Second, the resulting schemas from the first step are used to construct export schemas which are then integrated into global, individual schemas or views, in the third step. In this paper we focus on the first step for relational databases, i.e., the connection of a relational database system and the mapping of the relational model into a canonical data model. We take POSTGRES as the relational database system and the object-oriented federated database system VODAK as the integration platform which provides the open, object-oriented data model as the canonical data model for the integration. We show different variations of mapping the relational model. By exploiting the metaclass concept provided by VML, the modelling language of VODAK, we show how to tailor VML such that the canonical data model meets the requirements of integrating POSTGRES into the global database system VODAK in an efficient way.

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Using Stored Behaviour in Object-Oriented Databases

The existing standard for object-oriented databases (ODMG) provides no facility for storing behaviour. This lack of stored behaviour introduces problems for generic applications as well as multimedia and federated database systems. Research by others on this issue has resulted in proprietary solutions using non-standard object-oriented database models. This paper discusses types of behaviour in...

متن کامل

Designing a User-Oriented Query Modification Facility in Object-Oriented Database Systems

The introduction of user-assisting features into database systems is discussed along two stages. The first stage involves a basic facility that can be used with standard database systems, whereas in the second stage such features are expanded in order to cope with object-oriented systems, adopting semantically richer data models. Examples involving categorization and role-specialization semanti...

متن کامل

Apply Uncertainty in Document-Oriented Database (MongoDB) Using F-XML

As moving to big data world where data is increasing in unstructured way with high velocity, there is a need of data-store to store this bundle amount of data. Traditionally, relational databases are used which are now not compatible to handle this large amount of data, so it is needed to move on to non-relational data-stores. In the current study, we have proposed an extension of the Mongo...

متن کامل

User-Oriented Query Modification in Metaclass Systems

The introduction of user-assisting features into database systems is discussed along two stages. The first stage involves a basic facility that can be used with standard database systems, whereas in the second stage such features are expanded in order to cope with object-oriented systems, adopting semantically richer data models. Examples involving categorization and role-specialization semanti...

متن کامل

Apply Uncertainty in Document-Oriented Database (MongoDB) Using F-XML

As moving to big data world where data is increasing in unstructured way with high velocity, there is a need of data-store to store this bundle amount of data. Traditionally, relational databases are used which are now not compatible to handle this large amount of data, so it is needed to move on to non-relational data-stores. In the current study, we have proposed an extension of the Mongo...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

عنوان ژورنال:
  • Journal of Systems Integration

دوره 4  شماره 

صفحات  -

تاریخ انتشار 1994